package com.jnu.hc.jnuhcusercms.mapper;

import com.jnu.hc.jnuhcusercms.domain.Overallresult;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface OverallresultMapper {
    int deleteByPrimaryKey(Integer orId);

    int insert(Overallresult record);

    int insertSelective(Overallresult record);

    Overallresult selectByPrimaryKey(Integer orId);

    int updateByPrimaryKeySelective(Overallresult record);

    int updateByPrimaryKey(Overallresult record);
    @Select("select * from overallresult where orderId=#{orderId} order by orId")
    public List<Overallresult> listOverallResultByOrderId(Integer orderId);
    @Insert("insert into overallresult values(null,#{title},#{content},#{orderId})")
    public int saveOverallResult(Overallresult overallResult);
    @Update("update overallresult set title=#{title},content=#{content} where orId=#{orId}")
    public int updateOverallResult(Overallresult overallResult);
    @Delete("delete from overallresult where orId=#{orId}")
    public int removeOverallResult(Integer orId);

}